﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'up_UtilityAssetTransformers_SelectForExcel')
	DROP PROCEDURE up_UtilityAssetTransformers_SelectForExcel
GO



CREATE PROCEDURE [dbo].[up_UtilityAssetTransformers_SelectForExcel]
	 @UtilityFk int 
	,@SearchByType varchar(50) = null
	,@SearchByText varchar(50) = null
AS

SET NOCOUNT ON	

SELECT 
 	 Transformer.[Utility_Asset_TransformerId] AS [Asset]
	,Transformer.SerialNumber AS [Serial Number]
	,Transformer.Comments	
	,Transformer.[Latitude] AS [Latitude]
	,Transformer.[Longitude] AS [Longitude]	
from 
	tb_Utility_Asset_Transformers Transformer
WHERE
	Transformer.[UtilityFK] = @UtilityFk
 